Tabela CO_ORDERITEM

Definicja tabeli CO_ORDERITEM

Name

CO_ORDERITEM

Code

CO_ORDERITEM

Comment

 


Lista kolumn tabeli CO_ORDERITEM

Name

Code

ORDERITEMID

ORDERITEMID

ORDERID

ORDERID

DIETID

DIETID

MEALTYPEID

MEALTYPEID

QUANTITY

QUANTITY

NOTE

NOTE

INSERTDT

INSERTDT

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

INSERTDATE

INSERTDATE

DELIVERYDT

DELIVERYDT


Kolumna ORDERITEMID tabeli CO_ORDERITEM

Definicja kolumny ORDERITEMID tabeli CO_ORDERITEM

Name

ORDERITEMID

Code

ORDERITEMID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ORDERID tabeli CO_ORDERITEM

Definicja kolumny ORDERID tabeli CO_ORDERITEM

Name

ORDERID

Code

ORDERID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DIETID tabeli CO_ORDERITEM

Definicja kolumny DIETID tabeli CO_ORDERITEM

Name

DIETID

Code

DIETID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MEALTYPEID tabeli CO_ORDERITEM

Definicja kolumny MEALTYPEID tabeli CO_ORDERITEM

Name

MEALTYPEID

Code

MEALTYPEID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna QUANTITY tabeli CO_ORDERITEM

Definicja kolumny QUANTITY tabeli CO_ORDERITEM

Name

QUANTITY

Code

QUANTITY

Data Type

NUMBER(20,8)

Mandatory

Yes

Comment

 


Kolumna NOTE tabeli CO_ORDERITEM

Definicja kolumny NOTE tabeli CO_ORDERITEM

Name

NOTE

Code

NOTE

Data Type

VARCHAR2(1020)

Mandatory

No

Comment

 


Kolumna INSERTDT tabeli CO_ORDERITEM

Definicja kolumny INSERTDT tabeli CO_ORDERITEM

Name

INSERTDT

Code

INSERTDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_ORDERITEM

Definicja kolumny INSERTINGPERSON tabeli CO_ORDERITEM

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_ORDERITEM

Definicja kolumny LASTMODIFIEDDT tabeli CO_ORDERITEM

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_ORDERITEM

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_ORDERITEM

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna INSERTDATE tabeli CO_ORDERITEM

Definicja kolumny INSERTDATE tabeli CO_ORDERITEM

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DELIVERYDT tabeli CO_ORDERITEM

Definicja kolumny DELIVERYDT tabeli CO_ORDERITEM

Name

DELIVERYDT

Code

DELIVERYDT

Data Type

DATE

Mandatory

Yes

Comment

daty dostawy tej pozycji


Lista kluczy tabeli CO_ORDERITEM

Name

Code

Primary

PK_CO_ORDERITEM

PK_CO_ORDERITEM

X


Klucz PK_CO_ORDERITEM tabeli CO_ORDERITEM

Definicja klucza PK_CO_ORDERITEM tabeli CO_ORDERITEM

Name

PK_CO_ORDERITEM

Code

PK_CO_ORDERITEM

Primary

Yes

Comment